MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Artist Role = 428

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Culture, Artist Prefix, Medium, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
108463 29.100.414 0 1 196483 European Sculpture and Decorative Arts 3 Statuette 14 Woman Seated in Chair Wiping her Left Side French 7         Founder|Artist 428 Cast by A.-A. Hébrard et Cie|Edgar Degas Paris|French, Paris 1834–1917 Paris   A.-A. Hébrard et Cie|Degas, Edgar 9726 French 2 1834 1917 modeled probably ca. 1896–1900, cast 1920 1891 1920 Bronze 23 14-1/4 x 14-1/4 x 9-3/4 in. (36.2 x 36.2 x 24.8 cm.) H.O. Havemeyer Collection, Bequest of Mrs. H.O. Havemeyer, 1929                       Sculpture-Bronze 304   Metropolitan Museum of Art, New York, NY 1
113640 57.20 0 1 201957 European Sculpture and Decorative Arts 3 Bust 5 Pope Alexander VII (1599–1667) Italian, Rome 549         Founder|Artist 428 Cast by Giovanni Piscina|Melchiorre Cafà Maltese, 1638–1667   Piscina Giovanni|Cafà, Melchiorre 10805 Maltese 334 1638 1667 1667 1667 1667 Bronze 23 Overall (confirmed): 39 1/4 x 34 1/4 x 16 1/2 in., 145 lb. (99.7 x 87 x 41.9 cm, 65.7716 kg) Edith Perry Chapman Fund, 1957                       Sculpture-Bronze 304   Metropolitan Museum of Art, New York, NY 1
117788 1978.55 0 1 206715 European Sculpture and Decorative Arts 3 Group 3937 Allegory of the Maréchal de Villars’s Victory at Denain French, Paris 114         Founder|Artist 428 Cast and later modified by|Model by Pierre Philippe Thomire|Louis Simon Boizot French, Paris 1751–1843 Paris|French, Paris 1743–1809 Paris   Thomire, Pierre Philippe|Boizot, Louis Simon 11563 French|French 21 1751 |1743 1843 |1809 1806, modified 1818 1806 1806 Bronze 23 Overall (confirmed): H. 35 x W. 27 x D. 18 5/8 in. (88.9 x 68.6 x 47.3 cm) Purchase, Mr. and Mrs. Claus von Bülow Gift, Mr. and Mrs. Charles C. Paterson Gift, Bequest of Louis Einstein, by exchange, Rogers Fund and funds from various donors, 1978                       Sculpture-Bronze 304   Metropolitan Museum of Art, New York, NY 1
118392 1983.450 0 1 207397 European Sculpture and Decorative Arts 3 Bust 5 Francesco I de' Medici (1541–1587), Grand Duke of Tuscany Italian, Florence 1136         Founder|Artist 428 Probably cast by|After a model by Pietro Tacca|Giambologna Italian, Carrara 1577–1640 Florence|Netherlandish, Douai 1529–1608 Florence   Tacca, Pietro|Giambologna 11669 Italian|Netherlandish 342 1577 |1529 1640 |1608 modeled 1585–87, cast ca. 1611 1580 1616 Bronze 23 Overall (confirmed): H. 30 3/8 x W. 24 1/2 x D. 13 11/16 in. (77.2 x 62.2 x 34.7 cm) Purchase, Gift of Irwin Untermyer and Bequest of Ella Morris de Peyster, by exchange; Edith Perry Chapman Bequest; Robert Lehman Foundation Inc. Gift; Edward J. Gallagher Jr. Bequest, in memory of his father, Edward Joseph Gallagher, his mother, Ann Hay Gallagher, and his son, Edward Joseph Gallagher III; and Harris Brisbane Dick, Rogers, Pfeiffer, Louis V. Bell and Dodge Funds, 1983                       Sculpture-Bronze 304   Metropolitan Museum of Art, New York, NY 1
424619 2015.762.3 0 1 705237 European Sculpture and Decorative Arts 3 Medallion 72 Ferdinand Victor Eugène Delacroix (1798–1863) French 7         Founder|Artist 428 Medalist: Richard Frères|Pierre Jean David d'Angers French|French, Angers 1788–1856 Paris   Richard Frères|David d'Angers, Pierre Jean 54162   1788 1856 1828 1828 1828 Bronze 23 4 3/16 × 4 3/16 in. (10.7 × 10.7 cm) Gift of Maria Reinis, in memory of Joseph G. Reinis, 2015                       Medals and Plaquettes 306   Metropolitan Museum of Art, New York, NY 1
456256 2018.25a, b 0 0 769187 European Sculpture and Decorative Arts 3 Statuette 14 Galatea German 27         Founder|Artist 428 Cast by Noack and Brückner Foundry|Max Klinger German|German, Leipzig 1857–1920 Großjena   Noack and Brückner Foundry|Klinger, Max 58339   1857 1920 1906 1906 1906 Cast silver; marble 63603 Overall (figure): 31 1/2 × 12 3/16 × 13 3/8 in. (80 × 31 × 34 cm); Overall (base): 21 15/16 × 10 5/8 × 13 3/8 in. (55.7 × 27 × 34 cm); Height (total): 43 7/8 in. (111.5 cm)                         Sculpture 12   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 119.334ms · Data license: CC0 · Data source: metmuseum/openaccess